2014-10-22 - 15231.100 - Spec - Regional Reporting #RegionalReporting
SPECIFICATIONS
15231.100 - Regional Reporting
Requirement Summary
Need to develop regional cubes(attached document for combining sales orgs) and also develop Analysis queries for each of the regional cubes.
Admin Info
Purpose
|
Need to develop regional cubes(attached document for combining sales orgs) and also develop Analysis queries for each of the regional cubes.
|
Requested By
|
Pete Augustine
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
10/22/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Regional Cubes
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
40
|
2
|
Documentation
|
40
|
3
|
Development/ Config
|
140
|
4
|
Unit test in DEV
|
20
|
5
|
Unit test in QUA
|
20
|
6
|
Other activity
|
40
|
|
TOTAL
|
300
|
References
Prior Tickets
12560.100
Documents
BI-regional-reporting.pptx
New Regions by Sales Organizations.xlsb
MasterReportsList.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
|
|
|
|
2
|
|
|
|
|
3
|
|
|
|
|
4
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Mark.G:
Regional reporting
- Develop regional cubes (attached document for combining sales orgs)
i. Corporate with all data
ii. EMEA
iii. Emerging
1. Emerging – Americas
2. Emerging – JAPAC
iv. North America
v. Japan
- Move cubes to QA for testing by end of week.
- Develop Analysis queries for each of the regional cubes.
In Scope:
Split the Emerging region in to Emerging Americas & Emerging JAPAC.
Out of Scope:
None
Solution Summary
1. Need to create Semantically Partitioned object(SPO) with five partitions based on regions for COPA Source.
2. Need to create Semantically Partitioned object(SPO) with five partitions based on regions for Open Order Source.
3. Need to create Semantically Partitioned object(SPO) with five partitions based on regions for Contract Source.
4. Need to create Semantically Partitioned object(SPO) with five partitions based on regions for Condition Source.
5. Need to create regional Multiproviders on the regional sources.
6. Need to create process chains for all the above sources.
7. Need to create the queries on the regional sources as specified by NEC.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Check if the SPOs are having correct regional information.
|
SPOs should have correct regional information.
|
2
|
Check if all the correct SPOs are included under regional multiprovider.
|
Correct SPOs should be included under the regional multiprovider.
|
3
|
Check if all the regional versions of the BEx queries are defined.
|
All the regional versions of the BEx queries should be defined correctly.
|
Solution Details
1. Need to create Semantically Partitioned Object(SPO) with five partitions based on regions for COPA Source(Z_COPA) and need to load data from ZIC_COPA(NEC COPA) InfoCube and ZDSOCOPA(COPA Inter Company DSO) daily.
2. Need to create Semantically Partitioned Object(SPO) with five partitions based on regions for Open Order Source(Z_OPN) and need to load data from ZAFSDDS1(AFS Sales Orders DSO) daily.
3. Need to create Semantically Partitioned Object(SPO) with five partitions based on regions for Contract Source(Z_CNTR) and need to load data from ZAFSDDS1(AFS Sales Orders DSO) daily.
4. Need to create Semantically Partitioned Object(SPO) with five partitions based on regions for Condition Source(Z_COND) and need to load data from ZSDC_OPN(Open Orders InfoCube) and ZSD_CONTR(Contract Order Cube) daily.
5. Need to create regional multiproviders on the regional sources.
6. Need to create the Process Chains for all the above sources to automate the data loads once the data validation is successful.
7. Need to create the BEx queries on the regional sources as specified by NEC.
Issues
Emerging Americas and Emerging JAPAC run at the same time as that of the global process chains causing greater load on the system and leading to some performance issues.